<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Creating view filters on a rank range of metric values</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
ol.whs1 { list-style:decimal; }
-->
</style><script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Analyzing report and document results\nRestricting report results: Filtering\nCreating a filter based on a rank range of metric values");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Creating a filter based on a rank range of metric values</h1>
<p>You can create a filter that restricts report results based on a rank 
 range of metric values for a given report. This can allow you to view 
 analysis such as the bottom 20 products in terms of profit margin. Further 
 analysis can be explored on this rank range of products to determine how 
 to increase profit margins for these products, or decide which products 
 should be discontinued. </p>
<p>The steps below show you how to create a filter with a rank metric qualification. 
 </p>
<h2>Prerequisites</h2>
<ul>
<li class=p><p>You need the Web Use View Filter Editor privilege. This 
 privilege is part of OLAP Services.</p></li>
</ul>
<h2>To create a filter with a rank metric qualification</h2>
<ol type="1" class="whs1">
	
<li class=p><p>Log into a project in MicroStrategy Web. </p></li>
	
<li class=p><p>Run the report in Grid View. </p></li>
	
<li class=p><p>Right-click a metric on the report and select <span 
 style="font-weight: bold;"><B>Filter On</B></span>. </p></li>
	
<li class=p><p>Select <span style="font-weight: bold;"><B>Top N</B></span>. 
 The Filter On Metric dialog box opens.</p></li>
	
<li class=p><p>Select an operator from the drop-down list that describes 
 how you want to filter data, such as Highest or Lowest. </p></li>
	
<li class=p><p>Type the value for the rank number you want to restrict 
 data to. This is the value that indicates the number of attributes you 
 want to display.</p></li>
	
<li class=p><p>Click <span style="font-weight: bold;"><B>OK</B></span>. </p></li>
</ol>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
